/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : localhost:3306
 Source Schema         : lshop7

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 04/10/2019 16:19:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `order` int(11) NOT NULL DEFAULT '0',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uri` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permission` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `admin_menu` VALUES (1, 0, 1, '首页', 'fa-bar-chart', '/', NULL, NULL, '2019-09-29 23:52:04');
INSERT INTO `admin_menu` VALUES (2, 0, 6, '系统管理', 'fa-tasks', NULL, NULL, NULL, '2019-10-04 15:00:42');
INSERT INTO `admin_menu` VALUES (3, 2, 7, '管理员管理', 'fa-users', 'auth/users', NULL, NULL, '2019-10-04 15:00:42');
INSERT INTO `admin_menu` VALUES (4, 2, 8, '角色管理', 'fa-user', 'auth/roles', NULL, NULL, '2019-10-04 15:00:42');
INSERT INTO `admin_menu` VALUES (5, 2, 9, '权限管理', 'fa-ban', 'auth/permissions', NULL, NULL, '2019-10-04 15:00:42');
INSERT INTO `admin_menu` VALUES (6, 2, 10, '菜单管理', 'fa-bars', 'auth/menu', NULL, NULL, '2019-10-04 15:00:42');
INSERT INTO `admin_menu` VALUES (7, 2, 11, '操作记录', 'fa-history', 'auth/logs', NULL, NULL, '2019-10-04 15:00:42');
INSERT INTO `admin_menu` VALUES (8, 0, 2, '用户管理', 'fa-users', '/users', NULL, '2019-09-29 23:57:06', '2019-09-29 23:57:16');
INSERT INTO `admin_menu` VALUES (9, 0, 3, '商品管理', 'fa-cubes', '/products', NULL, '2019-09-30 09:45:02', '2019-09-30 09:45:06');
INSERT INTO `admin_menu` VALUES (10, 0, 4, '订单管理', 'fa-rmb', '/orders', NULL, '2019-10-03 23:55:29', '2019-10-03 23:55:44');
INSERT INTO `admin_menu` VALUES (11, 0, 5, '优惠券管理', 'fa-tags', '/coupon_codes', NULL, '2019-10-04 15:00:38', '2019-10-04 15:00:42');
COMMIT;

-- ----------------------------
-- Table structure for admin_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_operation_log`;
CREATE TABLE `admin_operation_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `input` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_operation_log_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_operation_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_operation_log` VALUES (1, 1, 'admin', 'GET', '127.0.0.1', '[]', '2019-09-29 23:51:26', '2019-09-29 23:51:26');
INSERT INTO `admin_operation_log` VALUES (2, 1, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:51:34', '2019-09-29 23:51:34');
INSERT INTO `admin_operation_log` VALUES (3, 1, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:51:34', '2019-09-29 23:51:34');
INSERT INTO `admin_operation_log` VALUES (4, 1, 'admin/auth/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:51:35', '2019-09-29 23:51:35');
INSERT INTO `admin_operation_log` VALUES (5, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:51:37', '2019-09-29 23:51:37');
INSERT INTO `admin_operation_log` VALUES (6, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:51:39', '2019-09-29 23:51:39');
INSERT INTO `admin_operation_log` VALUES (7, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:51:40', '2019-09-29 23:51:40');
INSERT INTO `admin_operation_log` VALUES (8, 1, 'admin/auth/menu/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:51:58', '2019-09-29 23:51:58');
INSERT INTO `admin_operation_log` VALUES (9, 1, 'admin/auth/menu/1', 'PUT', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u9996\\u9875\",\"icon\":\"fa-bar-chart\",\"uri\":\"\\/\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:52:04', '2019-09-29 23:52:04');
INSERT INTO `admin_operation_log` VALUES (10, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:52:04', '2019-09-29 23:52:04');
INSERT INTO `admin_operation_log` VALUES (11, 1, 'admin/auth/menu/2/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:52:06', '2019-09-29 23:52:06');
INSERT INTO `admin_operation_log` VALUES (12, 1, 'admin/auth/menu/2', 'PUT', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u7cfb\\u7edf\\u7ba1\\u7406\",\"icon\":\"fa-tasks\",\"uri\":null,\"roles\":[\"1\",null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:52:21', '2019-09-29 23:52:21');
INSERT INTO `admin_operation_log` VALUES (13, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:52:21', '2019-09-29 23:52:21');
INSERT INTO `admin_operation_log` VALUES (14, 1, 'admin/auth/menu/3/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:52:23', '2019-09-29 23:52:23');
INSERT INTO `admin_operation_log` VALUES (15, 1, 'admin/auth/menu/3', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u7ba1\\u7406\\u5458\",\"icon\":\"fa-users\",\"uri\":\"auth\\/users\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:52:31', '2019-09-29 23:52:31');
INSERT INTO `admin_operation_log` VALUES (16, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:52:31', '2019-09-29 23:52:31');
INSERT INTO `admin_operation_log` VALUES (17, 1, 'admin/auth/menu/4/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:52:37', '2019-09-29 23:52:37');
INSERT INTO `admin_operation_log` VALUES (18, 1, 'admin/auth/menu/4', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u89d2\\u8272\",\"icon\":\"fa-user\",\"uri\":\"auth\\/roles\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:52:42', '2019-09-29 23:52:42');
INSERT INTO `admin_operation_log` VALUES (19, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:52:42', '2019-09-29 23:52:42');
INSERT INTO `admin_operation_log` VALUES (20, 1, 'admin/auth/menu/5/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:52:44', '2019-09-29 23:52:44');
INSERT INTO `admin_operation_log` VALUES (21, 1, 'admin/auth/menu/5', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u6743\\u9650\",\"icon\":\"fa-ban\",\"uri\":\"auth\\/permissions\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:52:48', '2019-09-29 23:52:48');
INSERT INTO `admin_operation_log` VALUES (22, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:52:48', '2019-09-29 23:52:48');
INSERT INTO `admin_operation_log` VALUES (23, 1, 'admin/auth/menu/6/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:52:51', '2019-09-29 23:52:51');
INSERT INTO `admin_operation_log` VALUES (24, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:52:55', '2019-09-29 23:52:55');
INSERT INTO `admin_operation_log` VALUES (25, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:52:58', '2019-09-29 23:52:58');
INSERT INTO `admin_operation_log` VALUES (26, 1, 'admin/auth/menu/6/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:53:02', '2019-09-29 23:53:02');
INSERT INTO `admin_operation_log` VALUES (27, 1, 'admin/auth/menu/6', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u83dc\\u5355\\u7ba1\\u7406\",\"icon\":\"fa-bars\",\"uri\":\"auth\\/menu\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:53:09', '2019-09-29 23:53:09');
INSERT INTO `admin_operation_log` VALUES (28, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:53:09', '2019-09-29 23:53:09');
INSERT INTO `admin_operation_log` VALUES (29, 1, 'admin/auth/menu/7/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:53:11', '2019-09-29 23:53:11');
INSERT INTO `admin_operation_log` VALUES (30, 1, 'admin/auth/menu/7', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u64cd\\u4f5c\\u8bb0\\u5f55\",\"icon\":\"fa-history\",\"uri\":\"auth\\/logs\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:53:19', '2019-09-29 23:53:19');
INSERT INTO `admin_operation_log` VALUES (31, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:53:19', '2019-09-29 23:53:19');
INSERT INTO `admin_operation_log` VALUES (32, 1, 'admin/auth/menu/4/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:53:21', '2019-09-29 23:53:21');
INSERT INTO `admin_operation_log` VALUES (33, 1, 'admin/auth/menu/4', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u89d2\\u8272\\u7ba1\\u7406\",\"icon\":\"fa-user\",\"uri\":\"auth\\/roles\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:53:24', '2019-09-29 23:53:24');
INSERT INTO `admin_operation_log` VALUES (34, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:53:24', '2019-09-29 23:53:24');
INSERT INTO `admin_operation_log` VALUES (35, 1, 'admin/auth/menu/3/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:53:26', '2019-09-29 23:53:26');
INSERT INTO `admin_operation_log` VALUES (36, 1, 'admin/auth/menu/3', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u7ba1\\u7406\\u5458\\u7ba1\\u7406\",\"icon\":\"fa-users\",\"uri\":\"auth\\/users\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:53:30', '2019-09-29 23:53:30');
INSERT INTO `admin_operation_log` VALUES (37, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:53:30', '2019-09-29 23:53:30');
INSERT INTO `admin_operation_log` VALUES (38, 1, 'admin/auth/menu/5/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:53:33', '2019-09-29 23:53:33');
INSERT INTO `admin_operation_log` VALUES (39, 1, 'admin/auth/menu/5', 'PUT', '127.0.0.1', '{\"parent_id\":\"2\",\"title\":\"\\u6743\\u9650\\u7ba1\\u7406\",\"icon\":\"fa-ban\",\"uri\":\"auth\\/permissions\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/menu\"}', '2019-09-29 23:53:36', '2019-09-29 23:53:36');
INSERT INTO `admin_operation_log` VALUES (40, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:53:36', '2019-09-29 23:53:36');
INSERT INTO `admin_operation_log` VALUES (41, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:53:38', '2019-09-29 23:53:38');
INSERT INTO `admin_operation_log` VALUES (42, 1, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:53:39', '2019-09-29 23:53:39');
INSERT INTO `admin_operation_log` VALUES (43, 1, 'admin/auth/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:53:41', '2019-09-29 23:53:41');
INSERT INTO `admin_operation_log` VALUES (44, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:56:28', '2019-09-29 23:56:28');
INSERT INTO `admin_operation_log` VALUES (45, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"fa-users\",\"uri\":\"\\/users\",\"roles\":[null],\"permission\":null,\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\"}', '2019-09-29 23:57:06', '2019-09-29 23:57:06');
INSERT INTO `admin_operation_log` VALUES (46, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:57:06', '2019-09-29 23:57:06');
INSERT INTO `admin_operation_log` VALUES (47, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_order\":\"[{\\\"id\\\":1},{\\\"id\\\":8},{\\\"id\\\":2,\\\"children\\\":[{\\\"id\\\":3},{\\\"id\\\":4},{\\\"id\\\":5},{\\\"id\\\":6},{\\\"id\\\":7}]}]\"}', '2019-09-29 23:57:16', '2019-09-29 23:57:16');
INSERT INTO `admin_operation_log` VALUES (48, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:57:16', '2019-09-29 23:57:16');
INSERT INTO `admin_operation_log` VALUES (49, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-29 23:57:19', '2019-09-29 23:57:19');
INSERT INTO `admin_operation_log` VALUES (50, 1, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:57:21', '2019-09-29 23:57:21');
INSERT INTO `admin_operation_log` VALUES (51, 1, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:57:21', '2019-09-29 23:57:21');
INSERT INTO `admin_operation_log` VALUES (52, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:58:28', '2019-09-29 23:58:28');
INSERT INTO `admin_operation_log` VALUES (53, 1, 'admin/auth/permissions/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:58:30', '2019-09-29 23:58:30');
INSERT INTO `admin_operation_log` VALUES (54, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:58:35', '2019-09-29 23:58:35');
INSERT INTO `admin_operation_log` VALUES (55, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:58:40', '2019-09-29 23:58:40');
INSERT INTO `admin_operation_log` VALUES (56, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:58:41', '2019-09-29 23:58:41');
INSERT INTO `admin_operation_log` VALUES (57, 1, 'admin/auth/permissions/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:58:44', '2019-09-29 23:58:44');
INSERT INTO `admin_operation_log` VALUES (58, 1, 'admin/auth/permissions', 'POST', '127.0.0.1', '{\"slug\":\"users\",\"name\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"http_method\":[null],\"http_path\":\"\\/users*\",\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/permissions\"}', '2019-09-29 23:59:04', '2019-09-29 23:59:04');
INSERT INTO `admin_operation_log` VALUES (59, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '[]', '2019-09-29 23:59:04', '2019-09-29 23:59:04');
INSERT INTO `admin_operation_log` VALUES (60, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:59:20', '2019-09-29 23:59:20');
INSERT INTO `admin_operation_log` VALUES (61, 1, 'admin/auth/roles/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-29 23:59:21', '2019-09-29 23:59:21');
INSERT INTO `admin_operation_log` VALUES (62, 1, 'admin/auth/roles/create', 'GET', '127.0.0.1', '[]', '2019-09-30 00:00:37', '2019-09-30 00:00:37');
INSERT INTO `admin_operation_log` VALUES (63, 1, 'admin/auth/roles', 'POST', '127.0.0.1', '{\"slug\":\"operation\",\"name\":\"\\u8fd0\\u8425\",\"permissions\":[\"2\",\"3\",\"4\",\"6\",null],\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\"}', '2019-09-30 00:00:55', '2019-09-30 00:00:55');
INSERT INTO `admin_operation_log` VALUES (64, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '[]', '2019-09-30 00:00:55', '2019-09-30 00:00:55');
INSERT INTO `admin_operation_log` VALUES (65, 1, 'admin/auth/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 00:01:12', '2019-09-30 00:01:12');
INSERT INTO `admin_operation_log` VALUES (66, 1, 'admin/auth/users/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 00:01:17', '2019-09-30 00:01:17');
INSERT INTO `admin_operation_log` VALUES (67, 1, 'admin/auth/users', 'POST', '127.0.0.1', '{\"username\":\"operator\",\"name\":\"\\u8fd0\\u8425\",\"password\":\"123456\",\"password_confirmation\":\"123456\",\"roles\":[\"2\",null],\"permissions\":[null],\"_token\":\"Q478iO2cKpZI04SXQ6gJFmwjxp0wY49GlJzrGdr1\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/users\"}', '2019-09-30 00:02:18', '2019-09-30 00:02:18');
INSERT INTO `admin_operation_log` VALUES (68, 1, 'admin/auth/users', 'GET', '127.0.0.1', '[]', '2019-09-30 00:02:18', '2019-09-30 00:02:18');
INSERT INTO `admin_operation_log` VALUES (69, 1, 'admin/auth/logout', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 00:02:31', '2019-09-30 00:02:31');
INSERT INTO `admin_operation_log` VALUES (70, 2, 'admin', 'GET', '127.0.0.1', '[]', '2019-09-30 00:02:36', '2019-09-30 00:02:36');
INSERT INTO `admin_operation_log` VALUES (71, 2, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 00:02:42', '2019-09-30 00:02:42');
INSERT INTO `admin_operation_log` VALUES (72, 2, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 00:02:42', '2019-09-30 00:02:42');
INSERT INTO `admin_operation_log` VALUES (73, 2, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 00:02:43', '2019-09-30 00:02:43');
INSERT INTO `admin_operation_log` VALUES (74, 2, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 00:02:43', '2019-09-30 00:02:43');
INSERT INTO `admin_operation_log` VALUES (75, 2, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:40:07', '2019-09-30 09:40:07');
INSERT INTO `admin_operation_log` VALUES (76, 2, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:40:08', '2019-09-30 09:40:08');
INSERT INTO `admin_operation_log` VALUES (77, 2, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:40:09', '2019-09-30 09:40:09');
INSERT INTO `admin_operation_log` VALUES (78, 2, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:40:10', '2019-09-30 09:40:10');
INSERT INTO `admin_operation_log` VALUES (79, 2, 'admin/users', 'GET', '127.0.0.1', '[]', '2019-09-30 09:40:13', '2019-09-30 09:40:13');
INSERT INTO `admin_operation_log` VALUES (80, 2, 'admin', 'GET', '127.0.0.1', '[]', '2019-09-30 09:44:10', '2019-09-30 09:44:10');
INSERT INTO `admin_operation_log` VALUES (81, 2, 'admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:44:11', '2019-09-30 09:44:11');
INSERT INTO `admin_operation_log` VALUES (82, 2, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:44:13', '2019-09-30 09:44:13');
INSERT INTO `admin_operation_log` VALUES (83, 2, 'admin/auth/logout', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:44:14', '2019-09-30 09:44:14');
INSERT INTO `admin_operation_log` VALUES (84, 1, 'admin', 'GET', '127.0.0.1', '[]', '2019-09-30 09:44:23', '2019-09-30 09:44:23');
INSERT INTO `admin_operation_log` VALUES (85, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:44:30', '2019-09-30 09:44:30');
INSERT INTO `admin_operation_log` VALUES (86, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:44:33', '2019-09-30 09:44:33');
INSERT INTO `admin_operation_log` VALUES (87, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:44:36', '2019-09-30 09:44:36');
INSERT INTO `admin_operation_log` VALUES (88, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u5546\\u54c1\\u7ba1\\u7406\",\"icon\":\"fa-cubes\",\"uri\":\"\\/products\",\"roles\":[null],\"permission\":null,\"_token\":\"GN6xlYPRmkwXDocZo42rOrpYxCBEMiZOYW1XS92b\"}', '2019-09-30 09:45:02', '2019-09-30 09:45:02');
INSERT INTO `admin_operation_log` VALUES (89, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-30 09:45:02', '2019-09-30 09:45:02');
INSERT INTO `admin_operation_log` VALUES (90, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"_token\":\"GN6xlYPRmkwXDocZo42rOrpYxCBEMiZOYW1XS92b\",\"_order\":\"[{\\\"id\\\":1},{\\\"id\\\":8},{\\\"id\\\":9},{\\\"id\\\":2,\\\"children\\\":[{\\\"id\\\":3},{\\\"id\\\":4},{\\\"id\\\":5},{\\\"id\\\":6},{\\\"id\\\":7}]}]\"}', '2019-09-30 09:45:06', '2019-09-30 09:45:06');
INSERT INTO `admin_operation_log` VALUES (91, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:45:06', '2019-09-30 09:45:06');
INSERT INTO `admin_operation_log` VALUES (92, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-09-30 09:45:07', '2019-09-30 09:45:07');
INSERT INTO `admin_operation_log` VALUES (93, 1, 'admin/products', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:45:09', '2019-09-30 09:45:09');
INSERT INTO `admin_operation_log` VALUES (94, 1, 'admin/products', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:45:09', '2019-09-30 09:45:09');
INSERT INTO `admin_operation_log` VALUES (95, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:45:13', '2019-09-30 09:45:13');
INSERT INTO `admin_operation_log` VALUES (96, 1, 'admin/products/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:55:53', '2019-09-30 09:55:53');
INSERT INTO `admin_operation_log` VALUES (97, 1, 'admin/products/create', 'GET', '127.0.0.1', '[]', '2019-09-30 09:56:11', '2019-09-30 09:56:11');
INSERT INTO `admin_operation_log` VALUES (98, 1, 'admin/products', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:56:16', '2019-09-30 09:56:16');
INSERT INTO `admin_operation_log` VALUES (99, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:56:18', '2019-09-30 09:56:18');
INSERT INTO `admin_operation_log` VALUES (100, 1, 'admin/products/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:56:19', '2019-09-30 09:56:19');
INSERT INTO `admin_operation_log` VALUES (101, 1, 'admin/products', 'POST', '127.0.0.1', '{\"title\":\"Iphone X\",\"description\":\"<p>Iphone X \\u6982\\u5ff5\\u7248<\\/p>\",\"on_sale\":\"1\",\"skus\":{\"new_1\":{\"title\":\"\\u7070\\u8272 256g\",\"description\":\"iphone X \\u7070\\u8272 256g\",\"price\":\"8888\",\"stock\":\"100\",\"id\":null,\"_remove_\":\"0\"},\"new_2\":{\"title\":\"\\u7070\\u8272 521g\",\"description\":\"iphone X \\u767d\\u827264g\",\"price\":\"11000\",\"stock\":\"100\",\"id\":null,\"_remove_\":\"0\"}},\"_token\":\"GN6xlYPRmkwXDocZo42rOrpYxCBEMiZOYW1XS92b\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/products\"}', '2019-09-30 09:57:39', '2019-09-30 09:57:39');
INSERT INTO `admin_operation_log` VALUES (102, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:57:39', '2019-09-30 09:57:39');
INSERT INTO `admin_operation_log` VALUES (103, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:59:16', '2019-09-30 09:59:16');
INSERT INTO `admin_operation_log` VALUES (104, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:59:18', '2019-09-30 09:59:18');
INSERT INTO `admin_operation_log` VALUES (105, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:59:18', '2019-09-30 09:59:18');
INSERT INTO `admin_operation_log` VALUES (106, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:59:19', '2019-09-30 09:59:19');
INSERT INTO `admin_operation_log` VALUES (107, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:59:21', '2019-09-30 09:59:21');
INSERT INTO `admin_operation_log` VALUES (108, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:59:21', '2019-09-30 09:59:21');
INSERT INTO `admin_operation_log` VALUES (109, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:59:21', '2019-09-30 09:59:21');
INSERT INTO `admin_operation_log` VALUES (110, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:59:21', '2019-09-30 09:59:21');
INSERT INTO `admin_operation_log` VALUES (111, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:59:22', '2019-09-30 09:59:22');
INSERT INTO `admin_operation_log` VALUES (112, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:59:22', '2019-09-30 09:59:22');
INSERT INTO `admin_operation_log` VALUES (113, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 09:59:43', '2019-09-30 09:59:43');
INSERT INTO `admin_operation_log` VALUES (114, 1, 'admin/products/1', 'PUT', '127.0.0.1', '{\"title\":\"Apple\\/\\u82f9\\u679c Iphone X\",\"description\":\"<p>Iphone X \\u6982\\u5ff5\\u7248<\\/p>\",\"on_sale\":\"1\",\"skus\":{\"1\":{\"title\":\"\\u7070\\u8272 256g\",\"description\":\"iphone X \\u7070\\u8272 256g\",\"price\":\"8888.00\",\"stock\":\"100\",\"id\":\"1\",\"_remove_\":\"0\"},\"2\":{\"title\":\"\\u7070\\u8272 521g\",\"description\":\"iphone X \\u767d\\u827264g\",\"price\":\"11000.00\",\"stock\":\"100\",\"id\":\"2\",\"_remove_\":\"0\"}},\"_token\":\"GN6xlYPRmkwXDocZo42rOrpYxCBEMiZOYW1XS92b\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/products\"}', '2019-09-30 09:59:58', '2019-09-30 09:59:58');
INSERT INTO `admin_operation_log` VALUES (115, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 09:59:58', '2019-09-30 09:59:58');
INSERT INTO `admin_operation_log` VALUES (116, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 10:00:01', '2019-09-30 10:00:01');
INSERT INTO `admin_operation_log` VALUES (117, 1, 'admin/products', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 10:00:09', '2019-09-30 10:00:09');
INSERT INTO `admin_operation_log` VALUES (118, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 10:12:24', '2019-09-30 10:12:24');
INSERT INTO `admin_operation_log` VALUES (119, 1, 'admin', 'GET', '127.0.0.1', '[]', '2019-09-30 11:22:43', '2019-09-30 11:22:43');
INSERT INTO `admin_operation_log` VALUES (120, 1, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 11:22:45', '2019-09-30 11:22:45');
INSERT INTO `admin_operation_log` VALUES (121, 1, 'admin/products', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 11:22:45', '2019-09-30 11:22:45');
INSERT INTO `admin_operation_log` VALUES (122, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 11:22:47', '2019-09-30 11:22:47');
INSERT INTO `admin_operation_log` VALUES (123, 1, 'admin/products/1', 'PUT', '127.0.0.1', '{\"title\":\"Apple\\/\\u82f9\\u679c Iphone X\",\"description\":\"<p>Iphone X \\u6982\\u5ff5\\u7248<\\/p>\",\"on_sale\":\"0\",\"skus\":{\"1\":{\"title\":\"\\u7070\\u8272 256g\",\"description\":\"iphone X \\u7070\\u8272 256g\",\"price\":\"8888.00\",\"stock\":\"100\",\"id\":\"1\",\"_remove_\":\"0\"},\"2\":{\"title\":\"\\u7070\\u8272 521g\",\"description\":\"iphone X \\u767d\\u827264g\",\"price\":\"11000.00\",\"stock\":\"100\",\"id\":\"2\",\"_remove_\":\"0\"}},\"_token\":\"GN6xlYPRmkwXDocZo42rOrpYxCBEMiZOYW1XS92b\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/products\"}', '2019-09-30 11:22:51', '2019-09-30 11:22:51');
INSERT INTO `admin_operation_log` VALUES (124, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 11:22:51', '2019-09-30 11:22:51');
INSERT INTO `admin_operation_log` VALUES (125, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-09-30 11:23:04', '2019-09-30 11:23:04');
INSERT INTO `admin_operation_log` VALUES (126, 1, 'admin/products/1', 'PUT', '127.0.0.1', '{\"title\":\"Apple\\/\\u82f9\\u679c Iphone X\",\"description\":\"<p>Iphone X \\u6982\\u5ff5\\u7248<\\/p>\",\"on_sale\":\"1\",\"skus\":{\"1\":{\"title\":\"\\u7070\\u8272 256g\",\"description\":\"iphone X \\u7070\\u8272 256g\",\"price\":\"8888.00\",\"stock\":\"100\",\"id\":\"1\",\"_remove_\":\"0\"},\"2\":{\"title\":\"\\u7070\\u8272 521g\",\"description\":\"iphone X \\u767d\\u827264g\",\"price\":\"11000.00\",\"stock\":\"100\",\"id\":\"2\",\"_remove_\":\"0\"}},\"_token\":\"GN6xlYPRmkwXDocZo42rOrpYxCBEMiZOYW1XS92b\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/products\"}', '2019-09-30 11:23:08', '2019-09-30 11:23:08');
INSERT INTO `admin_operation_log` VALUES (127, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-09-30 11:23:08', '2019-09-30 11:23:08');
INSERT INTO `admin_operation_log` VALUES (128, 1, 'admin/products/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 12:22:59', '2019-10-03 12:22:59');
INSERT INTO `admin_operation_log` VALUES (129, 1, 'admin/products/1', 'PUT', '127.0.0.1', '{\"title\":\"Apple\\/\\u82f9\\u679c Iphone X\",\"description\":\"<p>Iphone X \\u6982\\u5ff5\\u7248<\\/p>\",\"on_sale\":\"0\",\"skus\":{\"1\":{\"title\":\"\\u7070\\u8272 256g\",\"description\":\"iphone X \\u7070\\u8272 256g\",\"price\":\"8888.00\",\"stock\":\"100\",\"id\":\"1\",\"_remove_\":\"0\"},\"2\":{\"title\":\"\\u7070\\u8272 521g\",\"description\":\"iphone X \\u767d\\u827264g\",\"price\":\"11000.00\",\"stock\":\"100\",\"id\":\"2\",\"_remove_\":\"0\"}},\"_token\":\"sCLdqnCrOrh5RFJPNaOVX7iVW47vy7qN7pNEvHQY\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/products\"}', '2019-10-03 12:23:03', '2019-10-03 12:23:03');
INSERT INTO `admin_operation_log` VALUES (130, 1, 'admin/products', 'GET', '127.0.0.1', '[]', '2019-10-03 12:23:03', '2019-10-03 12:23:03');
INSERT INTO `admin_operation_log` VALUES (131, 1, 'admin/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:54:54', '2019-10-03 23:54:54');
INSERT INTO `admin_operation_log` VALUES (132, 1, 'admin/products', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:54:55', '2019-10-03 23:54:55');
INSERT INTO `admin_operation_log` VALUES (133, 1, 'admin/auth/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:54:57', '2019-10-03 23:54:57');
INSERT INTO `admin_operation_log` VALUES (134, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:54:58', '2019-10-03 23:54:58');
INSERT INTO `admin_operation_log` VALUES (135, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:55:02', '2019-10-03 23:55:02');
INSERT INTO `admin_operation_log` VALUES (136, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:55:03', '2019-10-03 23:55:03');
INSERT INTO `admin_operation_log` VALUES (137, 1, 'admin/auth/users', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:55:04', '2019-10-03 23:55:04');
INSERT INTO `admin_operation_log` VALUES (138, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:55:08', '2019-10-03 23:55:08');
INSERT INTO `admin_operation_log` VALUES (139, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u8ba2\\u5355\\u7ba1\\u7406\",\"icon\":\"fa-rmb\",\"uri\":\"\\/orders\",\"roles\":[null],\"permission\":null,\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\"}', '2019-10-03 23:55:28', '2019-10-03 23:55:28');
INSERT INTO `admin_operation_log` VALUES (140, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-10-03 23:55:29', '2019-10-03 23:55:29');
INSERT INTO `admin_operation_log` VALUES (141, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-10-03 23:55:37', '2019-10-03 23:55:37');
INSERT INTO `admin_operation_log` VALUES (142, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\",\"_order\":\"[{\\\"id\\\":1},{\\\"id\\\":8},{\\\"id\\\":9},{\\\"id\\\":10},{\\\"id\\\":2,\\\"children\\\":[{\\\"id\\\":3},{\\\"id\\\":4},{\\\"id\\\":5},{\\\"id\\\":6},{\\\"id\\\":7}]}]\"}', '2019-10-03 23:55:44', '2019-10-03 23:55:44');
INSERT INTO `admin_operation_log` VALUES (143, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:55:44', '2019-10-03 23:55:44');
INSERT INTO `admin_operation_log` VALUES (144, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-10-03 23:55:45', '2019-10-03 23:55:45');
INSERT INTO `admin_operation_log` VALUES (145, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:55:47', '2019-10-03 23:55:47');
INSERT INTO `admin_operation_log` VALUES (146, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:55:47', '2019-10-03 23:55:47');
INSERT INTO `admin_operation_log` VALUES (147, 1, 'admin/orders/1', 'GET', '127.0.0.1', '[]', '2019-10-03 23:59:10', '2019-10-03 23:59:10');
INSERT INTO `admin_operation_log` VALUES (148, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-03 23:59:13', '2019-10-03 23:59:13');
INSERT INTO `admin_operation_log` VALUES (149, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-03 23:59:36', '2019-10-03 23:59:36');
INSERT INTO `admin_operation_log` VALUES (150, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-03 23:59:36', '2019-10-03 23:59:36');
INSERT INTO `admin_operation_log` VALUES (151, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-04 00:00:16', '2019-10-04 00:00:16');
INSERT INTO `admin_operation_log` VALUES (152, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 00:00:17', '2019-10-04 00:00:17');
INSERT INTO `admin_operation_log` VALUES (153, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:07:35', '2019-10-04 00:07:35');
INSERT INTO `admin_operation_log` VALUES (154, 1, 'admin/orders/9/ship', 'POST', '127.0.0.1', '{\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\",\"express_company\":null,\"express_no\":null}', '2019-10-04 00:07:36', '2019-10-04 00:07:36');
INSERT INTO `admin_operation_log` VALUES (155, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:07:37', '2019-10-04 00:07:37');
INSERT INTO `admin_operation_log` VALUES (156, 1, 'admin/orders/9/ship', 'POST', '127.0.0.1', '{\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\",\"express_company\":null,\"express_no\":null}', '2019-10-04 00:07:39', '2019-10-04 00:07:39');
INSERT INTO `admin_operation_log` VALUES (157, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:07:39', '2019-10-04 00:07:39');
INSERT INTO `admin_operation_log` VALUES (158, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:08:29', '2019-10-04 00:08:29');
INSERT INTO `admin_operation_log` VALUES (159, 1, 'admin/orders/9/ship', 'POST', '127.0.0.1', '{\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\",\"express_company\":null,\"express_no\":null}', '2019-10-04 00:08:30', '2019-10-04 00:08:30');
INSERT INTO `admin_operation_log` VALUES (160, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:08:30', '2019-10-04 00:08:30');
INSERT INTO `admin_operation_log` VALUES (161, 1, 'admin/orders/9/ship', 'POST', '127.0.0.1', '{\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\",\"express_company\":null,\"express_no\":null}', '2019-10-04 00:08:32', '2019-10-04 00:08:32');
INSERT INTO `admin_operation_log` VALUES (162, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:08:32', '2019-10-04 00:08:32');
INSERT INTO `admin_operation_log` VALUES (163, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:08:33', '2019-10-04 00:08:33');
INSERT INTO `admin_operation_log` VALUES (164, 1, 'admin/orders/9/ship', 'POST', '127.0.0.1', '{\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\",\"express_company\":\"\\u97f5\\u8fbe\",\"express_no\":\"23013274343737363\"}', '2019-10-04 00:08:42', '2019-10-04 00:08:42');
INSERT INTO `admin_operation_log` VALUES (165, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:08:42', '2019-10-04 00:08:42');
INSERT INTO `admin_operation_log` VALUES (166, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 00:16:24', '2019-10-04 00:16:24');
INSERT INTO `admin_operation_log` VALUES (167, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 01:08:46', '2019-10-04 01:08:46');
INSERT INTO `admin_operation_log` VALUES (168, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:08:49', '2019-10-04 01:08:49');
INSERT INTO `admin_operation_log` VALUES (169, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:08:50', '2019-10-04 01:08:50');
INSERT INTO `admin_operation_log` VALUES (170, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:08:52', '2019-10-04 01:08:52');
INSERT INTO `admin_operation_log` VALUES (171, 1, 'admin/orders/10', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:08:53', '2019-10-04 01:08:53');
INSERT INTO `admin_operation_log` VALUES (172, 1, 'admin/orders/10/ship', 'POST', '127.0.0.1', '{\"_token\":\"SZL6KhR85FsdWL9zn9sDXdZdlFNd2nhrM67fj0Ws\",\"express_company\":\"\\u97f5\\u8fbe\",\"express_no\":\"23013274343737364\"}', '2019-10-04 01:08:56', '2019-10-04 01:08:56');
INSERT INTO `admin_operation_log` VALUES (173, 1, 'admin/orders/10', 'GET', '127.0.0.1', '[]', '2019-10-04 01:08:56', '2019-10-04 01:08:56');
INSERT INTO `admin_operation_log` VALUES (174, 1, 'admin/orders/10', 'GET', '127.0.0.1', '[]', '2019-10-04 01:09:33', '2019-10-04 01:09:33');
INSERT INTO `admin_operation_log` VALUES (175, 1, 'admin/orders/10', 'GET', '127.0.0.1', '[]', '2019-10-04 01:12:32', '2019-10-04 01:12:32');
INSERT INTO `admin_operation_log` VALUES (176, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:12:35', '2019-10-04 01:12:35');
INSERT INTO `admin_operation_log` VALUES (177, 1, 'admin/orders/10', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:12:40', '2019-10-04 01:12:40');
INSERT INTO `admin_operation_log` VALUES (178, 1, 'admin/orders/10', 'GET', '127.0.0.1', '[]', '2019-10-04 01:12:42', '2019-10-04 01:12:42');
INSERT INTO `admin_operation_log` VALUES (179, 1, 'admin/orders/10', 'GET', '127.0.0.1', '[]', '2019-10-04 01:12:42', '2019-10-04 01:12:42');
INSERT INTO `admin_operation_log` VALUES (180, 1, 'admin/orders/10', 'GET', '127.0.0.1', '[]', '2019-10-04 01:34:46', '2019-10-04 01:34:46');
INSERT INTO `admin_operation_log` VALUES (181, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:34:52', '2019-10-04 01:34:52');
INSERT INTO `admin_operation_log` VALUES (182, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-04 01:36:17', '2019-10-04 01:36:17');
INSERT INTO `admin_operation_log` VALUES (183, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:36:19', '2019-10-04 01:36:19');
INSERT INTO `admin_operation_log` VALUES (184, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:36:20', '2019-10-04 01:36:20');
INSERT INTO `admin_operation_log` VALUES (185, 1, 'admin/orders/10', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:36:22', '2019-10-04 01:36:22');
INSERT INTO `admin_operation_log` VALUES (186, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 01:36:31', '2019-10-04 01:36:31');
INSERT INTO `admin_operation_log` VALUES (187, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-04 02:56:35', '2019-10-04 02:56:35');
INSERT INTO `admin_operation_log` VALUES (188, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 02:56:37', '2019-10-04 02:56:37');
INSERT INTO `admin_operation_log` VALUES (189, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-04 02:56:37', '2019-10-04 02:56:37');
INSERT INTO `admin_operation_log` VALUES (190, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-04 03:00:01', '2019-10-04 03:00:01');
INSERT INTO `admin_operation_log` VALUES (191, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 03:00:03', '2019-10-04 03:00:03');
INSERT INTO `admin_operation_log` VALUES (192, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 03:00:05', '2019-10-04 03:00:05');
INSERT INTO `admin_operation_log` VALUES (193, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 03:00:06', '2019-10-04 03:00:06');
INSERT INTO `admin_operation_log` VALUES (194, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 03:00:07', '2019-10-04 03:00:07');
INSERT INTO `admin_operation_log` VALUES (195, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 03:00:10', '2019-10-04 03:00:10');
INSERT INTO `admin_operation_log` VALUES (196, 1, 'admin/orders/10', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 03:00:11', '2019-10-04 03:00:11');
INSERT INTO `admin_operation_log` VALUES (197, 1, 'admin/orders', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 03:00:13', '2019-10-04 03:00:13');
INSERT INTO `admin_operation_log` VALUES (198, 1, 'admin/orders', 'GET', '127.0.0.1', '[]', '2019-10-04 03:00:14', '2019-10-04 03:00:14');
INSERT INTO `admin_operation_log` VALUES (199, 1, 'admin/orders/9', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 03:00:15', '2019-10-04 03:00:15');
INSERT INTO `admin_operation_log` VALUES (200, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 11:56:18', '2019-10-04 11:56:18');
INSERT INTO `admin_operation_log` VALUES (201, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 11:56:30', '2019-10-04 11:56:30');
INSERT INTO `admin_operation_log` VALUES (202, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 11:57:11', '2019-10-04 11:57:11');
INSERT INTO `admin_operation_log` VALUES (203, 1, 'admin/orders/9/refund', 'POST', '127.0.0.1', '{\"agree\":false,\"reason\":\"2121312313\",\"_token\":\"Hbkx7HE8EigrJ3bNBinG9veFdtQRcuT4Lyk3ml8E\"}', '2019-10-04 11:57:15', '2019-10-04 11:57:15');
INSERT INTO `admin_operation_log` VALUES (204, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 11:57:16', '2019-10-04 11:57:16');
INSERT INTO `admin_operation_log` VALUES (205, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 14:40:20', '2019-10-04 14:40:20');
INSERT INTO `admin_operation_log` VALUES (206, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 14:40:30', '2019-10-04 14:40:30');
INSERT INTO `admin_operation_log` VALUES (207, 1, 'admin/orders/9/refund', 'POST', '127.0.0.1', '{\"agree\":true,\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\"}', '2019-10-04 14:40:37', '2019-10-04 14:40:37');
INSERT INTO `admin_operation_log` VALUES (208, 1, 'admin/orders/9', 'GET', '127.0.0.1', '[]', '2019-10-04 14:40:47', '2019-10-04 14:40:47');
INSERT INTO `admin_operation_log` VALUES (209, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 15:00:07', '2019-10-04 15:00:07');
INSERT INTO `admin_operation_log` VALUES (210, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u4f18\\u60e0\\u5238\\u7ba1\\u7406\",\"icon\":\"fa-tags\",\"uri\":\"\\/coupon_codes\",\"roles\":[null],\"permission\":null,\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\"}', '2019-10-04 15:00:38', '2019-10-04 15:00:38');
INSERT INTO `admin_operation_log` VALUES (211, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-10-04 15:00:38', '2019-10-04 15:00:38');
INSERT INTO `admin_operation_log` VALUES (212, 1, 'admin/auth/menu', 'POST', '127.0.0.1', '{\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\",\"_order\":\"[{\\\"id\\\":1},{\\\"id\\\":8},{\\\"id\\\":9},{\\\"id\\\":10},{\\\"id\\\":11},{\\\"id\\\":2,\\\"children\\\":[{\\\"id\\\":3},{\\\"id\\\":4},{\\\"id\\\":5},{\\\"id\\\":6},{\\\"id\\\":7}]}]\"}', '2019-10-04 15:00:42', '2019-10-04 15:00:42');
INSERT INTO `admin_operation_log` VALUES (213, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 15:00:42', '2019-10-04 15:00:42');
INSERT INTO `admin_operation_log` VALUES (214, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '[]', '2019-10-04 15:00:44', '2019-10-04 15:00:44');
INSERT INTO `admin_operation_log` VALUES (215, 1, 'admin/coupon_codes', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 15:00:45', '2019-10-04 15:00:45');
INSERT INTO `admin_operation_log` VALUES (216, 1, 'admin/coupon_codes', 'GET', '127.0.0.1', '[]', '2019-10-04 15:04:02', '2019-10-04 15:04:02');
INSERT INTO `admin_operation_log` VALUES (217, 1, 'admin/coupon_codes', 'GET', '127.0.0.1', '[]', '2019-10-04 15:09:33', '2019-10-04 15:09:33');
INSERT INTO `admin_operation_log` VALUES (218, 1, 'admin/coupon_codes/10', 'DELETE', '127.0.0.1', '{\"_method\":\"delete\",\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\"}', '2019-10-04 15:09:37', '2019-10-04 15:09:37');
INSERT INTO `admin_operation_log` VALUES (219, 1, 'admin/coupon_codes', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 15:09:37', '2019-10-04 15:09:37');
INSERT INTO `admin_operation_log` VALUES (220, 1, 'admin/coupon_codes/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 15:09:40', '2019-10-04 15:09:40');
INSERT INTO `admin_operation_log` VALUES (221, 1, 'admin/coupon_codes/1', 'PUT', '127.0.0.1', '{\"name\":\"minima veritatis velit\",\"code\":\"ZTUE3TZT7YDFJEWE\",\"type\":\"percent\",\"value\":\"17.00\",\"total\":\"1000\",\"min_amount\":\"0.00\",\"not_before\":\"2019-10-04 00:00:00\",\"not_after\":\"2019-10-25 00:00:00\",\"enabled\":\"1\",\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/coupon_codes\"}', '2019-10-04 15:09:48', '2019-10-04 15:09:48');
INSERT INTO `admin_operation_log` VALUES (222, 1, 'admin/coupon_codes', 'GET', '127.0.0.1', '[]', '2019-10-04 15:09:48', '2019-10-04 15:09:48');
INSERT INTO `admin_operation_log` VALUES (223, 1, 'admin/coupon_codes/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 15:09:52', '2019-10-04 15:09:52');
INSERT INTO `admin_operation_log` VALUES (224, 1, 'admin/coupon_codes', 'POST', '127.0.0.1', '{\"name\":\"\\u6d4b\\u8bd5\\u4f18\\u60e0\\u5238\",\"code\":\"zhuleiaixuehua1314\",\"type\":\"fixed\",\"value\":\"10\",\"total\":\"10\",\"min_amount\":\"100\",\"not_before\":\"2019-10-04 00:00:00\",\"not_after\":\"2019-10-09 00:00:00\",\"enabled\":\"1\",\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/coupon_codes\"}', '2019-10-04 15:11:34', '2019-10-04 15:11:34');
INSERT INTO `admin_operation_log` VALUES (225, 1, 'admin/coupon_codes/create', 'GET', '127.0.0.1', '[]', '2019-10-04 15:11:34', '2019-10-04 15:11:34');
INSERT INTO `admin_operation_log` VALUES (226, 1, 'admin/coupon_codes', 'POST', '127.0.0.1', '{\"name\":\"\\u6d4b\\u8bd5\\u4f18\\u60e0\\u5238\",\"code\":\"zhuleiaixuehua1314\",\"type\":\"fixed\",\"value\":\"10\",\"total\":\"10\",\"min_amount\":\"100\",\"not_before\":\"2019-10-04 00:00:00\",\"not_after\":\"2019-10-09 00:00:00\",\"enabled\":\"1\",\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\"}', '2019-10-04 15:12:39', '2019-10-04 15:12:39');
INSERT INTO `admin_operation_log` VALUES (227, 1, 'admin/coupon_codes', 'GET', '127.0.0.1', '[]', '2019-10-04 15:12:39', '2019-10-04 15:12:39');
INSERT INTO `admin_operation_log` VALUES (228, 1, 'admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 16:12:32', '2019-10-04 16:12:32');
INSERT INTO `admin_operation_log` VALUES (229, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 16:12:33', '2019-10-04 16:12:33');
INSERT INTO `admin_operation_log` VALUES (230, 1, 'admin/auth/permissions/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 16:13:04', '2019-10-04 16:13:04');
INSERT INTO `admin_operation_log` VALUES (231, 1, 'admin/auth/permissions', 'POST', '127.0.0.1', '{\"slug\":\"products\",\"name\":\"\\u5546\\u54c1\\u7ba1\\u7406\",\"http_method\":[null],\"http_path\":\"\\/products*\",\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/permissions\"}', '2019-10-04 16:13:25', '2019-10-04 16:13:25');
INSERT INTO `admin_operation_log` VALUES (232, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '[]', '2019-10-04 16:13:25', '2019-10-04 16:13:25');
INSERT INTO `admin_operation_log` VALUES (233, 1, 'admin/auth/permissions/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 16:13:26', '2019-10-04 16:13:26');
INSERT INTO `admin_operation_log` VALUES (234, 1, 'admin/auth/permissions', 'POST', '127.0.0.1', '{\"slug\":\"coupon_codes\",\"name\":\"\\u4f18\\u60e0\\u5238\\u7ba1\\u7406\",\"http_method\":[null],\"http_path\":\"\\/coupon_codes*\",\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/permissions\"}', '2019-10-04 16:13:44', '2019-10-04 16:13:44');
INSERT INTO `admin_operation_log` VALUES (235, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '[]', '2019-10-04 16:13:44', '2019-10-04 16:13:44');
INSERT INTO `admin_operation_log` VALUES (236, 1, 'admin/auth/permissions/create', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 16:13:48', '2019-10-04 16:13:48');
INSERT INTO `admin_operation_log` VALUES (237, 1, 'admin/auth/permissions', 'POST', '127.0.0.1', '{\"slug\":\"orders\",\"name\":\"\\u8ba2\\u5355\\u7ba1\\u7406\",\"http_method\":[null],\"http_path\":\"\\/orders*\",\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\",\"_previous_\":\"http:\\/\\/local.shop.test\\/admin\\/auth\\/permissions\"}', '2019-10-04 16:14:01', '2019-10-04 16:14:01');
INSERT INTO `admin_operation_log` VALUES (238, 1, 'admin/auth/permissions', 'GET', '127.0.0.1', '[]', '2019-10-04 16:14:01', '2019-10-04 16:14:01');
INSERT INTO `admin_operation_log` VALUES (239, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 16:14:09', '2019-10-04 16:14:09');
INSERT INTO `admin_operation_log` VALUES (240, 1, 'admin/auth/roles/2/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2019-10-04 16:14:11', '2019-10-04 16:14:11');
INSERT INTO `admin_operation_log` VALUES (241, 1, 'admin/auth/roles/2/edit', 'GET', '127.0.0.1', '[]', '2019-10-04 16:14:19', '2019-10-04 16:14:19');
INSERT INTO `admin_operation_log` VALUES (242, 1, 'admin/auth/roles/2', 'PUT', '127.0.0.1', '{\"slug\":\"operation\",\"name\":\"\\u8fd0\\u8425\",\"permissions\":[\"2\",\"3\",\"4\",\"6\",\"7\",\"8\",\"9\",null],\"_token\":\"N1RIAspNEp6P7I2wt8glsGTJVSq8ZMgz2W0HqT0N\",\"_method\":\"PUT\"}', '2019-10-04 16:14:25', '2019-10-04 16:14:25');
INSERT INTO `admin_operation_log` VALUES (243, 1, 'admin/auth/roles', 'GET', '127.0.0.1', '[]', '2019-10-04 16:14:25', '2019-10-04 16:14:25');
COMMIT;

-- ----------------------------
-- Table structure for admin_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_permissions`;
CREATE TABLE `admin_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `http_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `http_path` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_permissions
-- ----------------------------
BEGIN;
INSERT INTO `admin_permissions` VALUES (1, 'All permission', '*', '', '*', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (2, 'Dashboard', 'dashboard', 'GET', '/', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (3, 'Login', 'auth.login', '', '/auth/login\r\n/auth/logout', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (4, 'User setting', 'auth.setting', 'GET,PUT', '/auth/setting', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (5, 'Auth management', 'auth.management', '', '/auth/roles\r\n/auth/permissions\r\n/auth/menu\r\n/auth/logs', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (6, '用户管理', 'users', '', '/users*', '2019-09-29 23:59:04', '2019-09-29 23:59:04');
INSERT INTO `admin_permissions` VALUES (7, '商品管理', 'products', '', '/products*', '2019-10-04 16:13:25', '2019-10-04 16:13:25');
INSERT INTO `admin_permissions` VALUES (8, '优惠券管理', 'coupon_codes', '', '/coupon_codes*', '2019-10-04 16:13:44', '2019-10-04 16:13:44');
INSERT INTO `admin_permissions` VALUES (9, '订单管理', 'orders', '', '/orders*', '2019-10-04 16:14:01', '2019-10-04 16:14:01');
COMMIT;

-- ----------------------------
-- Table structure for admin_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_menu`;
CREATE TABLE `admin_role_menu` (
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_menu` VALUES (1, 2, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_role_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_permissions`;
CREATE TABLE `admin_role_permissions` (
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_permissions_role_id_permission_id_index` (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_role_permissions
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_permissions` VALUES (1, 1, NULL, NULL);
INSERT INTO `admin_role_permissions` VALUES (2, 2, NULL, NULL);
INSERT INTO `admin_role_permissions` VALUES (2, 3, NULL, NULL);
INSERT INTO `admin_role_permissions` VALUES (2, 4, NULL, NULL);
INSERT INTO `admin_role_permissions` VALUES (2, 6, NULL, NULL);
INSERT INTO `admin_role_permissions` VALUES (2, 7, NULL, NULL);
INSERT INTO `admin_role_permissions` VALUES (2, 8, NULL, NULL);
INSERT INTO `admin_role_permissions` VALUES (2, 9, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_role_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_users`;
CREATE TABLE `admin_role_users` (
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_users_role_id_user_id_index` (`role_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_role_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_users` VALUES (1, 1, NULL, NULL);
INSERT INTO `admin_role_users` VALUES (2, 2, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_roles
-- ----------------------------
DROP TABLE IF EXISTS `admin_roles`;
CREATE TABLE `admin_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_roles
-- ----------------------------
BEGIN;
INSERT INTO `admin_roles` VALUES (1, 'Administrator', 'administrator', '2019-09-29 23:49:18', '2019-09-29 23:49:18');
INSERT INTO `admin_roles` VALUES (2, '运营', 'operation', '2019-09-30 00:00:55', '2019-09-30 00:00:55');
COMMIT;

-- ----------------------------
-- Table structure for admin_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_permissions`;
CREATE TABLE `admin_user_permissions` (
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_user_permissions_user_id_permission_id_index` (`user_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for admin_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_users` VALUES (1, 'admin', '$2y$10$5BsQ.7Fh5sZ0f0kB8SFYKe.NMWmlJ6HPPi1L6HhocT.HgykFqOJeC', 'Administrator', NULL, 'A2tpkLAMR87zgjNTmpZvbxnPMQwQiHq73zZrYYyksOpWPfBDbBJJS5CQwdEj', '2019-09-29 23:49:18', '2019-09-29 23:49:18');
INSERT INTO `admin_users` VALUES (2, 'operator', '$2y$10$LGVk4SQpHLoDjqsziGYZPeFsuE.dFTQdhcfIsyeMaSokK6zwBsQh2', '运营', 'images/6c256f91ly1fiexocsv42j20fu0lqtbb.jpg', 'lP5skDWZTvKDxUGJoIS5S7HY6z69uoLqsZyjWRITy1KCovDgA1RpvG59CiAc', '2019-09-30 00:02:18', '2019-09-30 00:02:18');
COMMIT;

-- ----------------------------
-- Table structure for cart_items
-- ----------------------------
DROP TABLE IF EXISTS `cart_items`;
CREATE TABLE `cart_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL COMMENT '关联用户id',
  `product_sku_id` bigint(20) unsigned NOT NULL COMMENT '关联商品sku_id',
  `amount` int(10) unsigned NOT NULL COMMENT '商品数量',
  PRIMARY KEY (`id`),
  KEY `cart_items_user_id_foreign` (`user_id`),
  KEY `cart_items_product_sku_id_foreign` (`product_sku_id`),
  CONSTRAINT `cart_items_product_sku_id_foreign` FOREIGN KEY (`product_sku_id`) REFERENCES `product_skus` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_items_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for coupon_codes
-- ----------------------------
DROP TABLE IF EXISTS `coupon_codes`;
CREATE TABLE `coupon_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '优惠券标题',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '优惠码',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '优惠类型',
  `value` decimal(8,2) NOT NULL COMMENT '优惠金额',
  `total` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '总数量',
  `used` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `min_amount` decimal(10,2) NOT NULL COMMENT '使用该优惠券的最低订单金额',
  `not_before` datetime DEFAULT NULL COMMENT '在这个时间之前不可用',
  `not_after` datetime DEFAULT NULL COMMENT '在这个时间之后不可用',
  `enabled` tinyint(1) NOT NULL COMMENT '优惠券是否生效',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupon_codes_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of coupon_codes
-- ----------------------------
BEGIN;
INSERT INTO `coupon_codes` VALUES (1, 'minima veritatis velit', 'ZTUE3TZT7YDFJEWE', 'percent', 17.00, 1000, 0, 0.00, '2019-10-04 00:00:00', '2019-10-25 00:00:00', 1, '2019-10-04 15:02:23', '2019-10-04 15:09:48');
INSERT INTO `coupon_codes` VALUES (2, 'dolorem repellat expedita', 'ZH0DLQD735KDT4ET', 'percent', 35.00, 1000, 0, 977.00, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (3, 'ad et distinctio', '6KVOOYC0HPSAPVNP', 'percent', 13.00, 1000, 0, 0.00, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (4, 'inventore officiis dolore', '02FJJFR9X2PTCMPT', 'percent', 11.00, 1000, 0, 0.00, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (5, 'saepe enim id', 'M4SIJDUMA5WDLVVW', 'percent', 9.00, 1000, 0, 0.00, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (6, 'repellendus enim dolorem', 'OCRD8VKYFBLRLXV1', 'fixed', 127.00, 1000, 0, 127.01, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (7, 'maxime esse eum', 'XHV5HO8HSIJFTRPL', 'fixed', 41.00, 1000, 0, 41.01, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (8, 'adipisci voluptas quasi', 'CDI05KXP6GGH6EWZ', 'fixed', 98.00, 1000, 0, 98.01, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (9, 'voluptatem minima quidem', 'R5MOXLJ6JKLJX2DN', 'fixed', 150.00, 1000, 0, 150.01, NULL, NULL, 1, '2019-10-04 15:02:23', '2019-10-04 15:02:23');
INSERT INTO `coupon_codes` VALUES (11, '测试优惠券', 'zhuleiaixuehua1314', 'fixed', 10.00, 10, 1, 100.00, '2019-10-04 00:00:00', '2019-10-09 00:00:00', 1, '2019-10-04 15:12:39', '2019-10-04 16:11:57');
COMMIT;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of migrations
-- ----------------------------
BEGIN;
INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (3, '2019_09_29_090248_create_user_addresses_table', 2);
INSERT INTO `migrations` VALUES (4, '2016_01_04_173148_create_admin_tables', 3);
INSERT INTO `migrations` VALUES (5, '2019_09_30_092602_create_products_table', 4);
INSERT INTO `migrations` VALUES (6, '2019_09_30_092608_create_product_skus_table', 4);
INSERT INTO `migrations` VALUES (7, '2019_09_30_112422_create_user_favorite_products_table', 5);
INSERT INTO `migrations` VALUES (8, '2019_09_30_115005_create_cart_items_table', 6);
INSERT INTO `migrations` VALUES (9, '2019_09_30_145501_create_orders_table', 7);
INSERT INTO `migrations` VALUES (10, '2019_09_30_145535_create_order_items_table', 7);
INSERT INTO `migrations` VALUES (11, '2019_10_04_144929_create_coupon_codes_table', 8);
INSERT INTO `migrations` VALUES (12, '2019_10_04_145602_orders_add_coupon_code_id', 8);
COMMIT;

-- ----------------------------
-- Table structure for order_items
-- ----------------------------
DROP TABLE IF EXISTS `order_items`;
CREATE TABLE `order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `product_sku_id` bigint(20) unsigned NOT NULL,
  `amount` int(10) unsigned NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `rating` int(10) unsigned DEFAULT NULL,
  `review` text COLLATE utf8mb4_unicode_ci,
  `reviewed_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  KEY `order_items_product_id_foreign` (`product_id`),
  KEY `order_items_product_sku_id_foreign` (`product_sku_id`),
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_product_sku_id_foreign` FOREIGN KEY (`product_sku_id`) REFERENCES `product_skus` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of order_items
-- ----------------------------
BEGIN;
INSERT INTO `order_items` VALUES (1, 1, 2, 3, 1, 8818.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (2, 2, 2, 4, 1, 4586.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (3, 3, 4, 10, 1, 9119.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (4, 4, 3, 8, 1, 1428.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (5, 5, 5, 12, 1, 9106.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (6, 6, 6, 17, 1, 4565.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (7, 7, 8, 21, 1, 2984.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (8, 8, 7, 20, 1, 9640.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (9, 9, 9, 25, 1, 903.00, 4, '还可以', '2019-10-04 00:42:39');
INSERT INTO `order_items` VALUES (10, 10, 2, 4, 1, 4586.00, 5, 'sssss', '2019-10-04 01:12:25');
INSERT INTO `order_items` VALUES (11, 11, 3, 7, 1, 6457.00, NULL, NULL, NULL);
INSERT INTO `order_items` VALUES (12, 12, 5, 13, 1, 3403.00, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单流水号',
  `user_id` bigint(20) unsigned NOT NULL COMMENT '关联用户id',
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '地址',
  `total_amount` decimal(10,2) NOT NULL COMMENT '总价',
  `remark` text COLLATE utf8mb4_unicode_ci COMMENT '订单备注',
  `paid_at` datetime DEFAULT NULL COMMENT '支付时间',
  `coupon_code_id` bigint(20) unsigned DEFAULT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付方式',
  `payment_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付订单号',
  `refund_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT '退款状态',
  `refund_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '退款单号',
  `closed` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单是否关闭',
  `reviewed` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单是否已评价',
  `ship_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT '发货状态',
  `ship_data` text COLLATE utf8mb4_unicode_ci COMMENT '物流状态',
  `extra` text COLLATE utf8mb4_unicode_ci COMMENT '其他额外数据',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_refund_no_unique` (`refund_no`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_coupon_code_id_foreign` (`coupon_code_id`),
  CONSTRAINT `orders_coupon_code_id_foreign` FOREIGN KEY (`coupon_code_id`) REFERENCES `coupon_codes` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of orders
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES (1, '20191003122603323493', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 8818.00, '213213123', NULL, NULL, NULL, NULL, 'pending', NULL, 0, 0, 'pending', NULL, NULL, '2019-10-03 12:26:03', '2019-10-03 12:26:03');
INSERT INTO `orders` VALUES (2, '20191003125759624782', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 4586.00, '213213123', NULL, NULL, NULL, NULL, 'pending', NULL, 1, 0, 'pending', NULL, NULL, '2019-10-03 12:57:59', '2019-10-03 12:58:32');
INSERT INTO `orders` VALUES (3, '20191003173352424759', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 9119.00, 'rtyj', NULL, NULL, NULL, NULL, 'pending', NULL, 1, 0, 'pending', NULL, NULL, '2019-10-03 17:33:52', '2019-10-03 18:03:53');
INSERT INTO `orders` VALUES (4, '20191003180026933178', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 1428.00, 'awdasdasdsadsa', NULL, NULL, NULL, NULL, 'pending', NULL, 1, 0, 'pending', NULL, NULL, '2019-10-03 18:00:26', '2019-10-03 18:30:26');
INSERT INTO `orders` VALUES (5, '20191003180908974597', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 9106.00, 'sadsdfsfs', NULL, NULL, NULL, NULL, 'pending', NULL, 1, 0, 'pending', NULL, NULL, '2019-10-03 18:09:08', '2019-10-03 18:39:09');
INSERT INTO `orders` VALUES (6, '20191003181215246390', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 4565.00, 'sdfcggfd', NULL, NULL, NULL, NULL, 'pending', NULL, 1, 0, 'pending', NULL, NULL, '2019-10-03 18:12:15', '2019-10-03 18:42:16');
INSERT INTO `orders` VALUES (7, '20191003190442941688', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 2984.00, '12345', NULL, NULL, NULL, NULL, 'pending', NULL, 1, 0, 'pending', NULL, NULL, '2019-10-03 19:04:42', '2019-10-03 19:34:43');
INSERT INTO `orders` VALUES (8, '20191003202146940835', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 9640.00, 'dsfbdjhfgdhjsfghjsd', NULL, NULL, NULL, NULL, 'pending', NULL, 1, 0, 'pending', NULL, NULL, '2019-10-03 20:21:46', '2019-10-03 20:51:47');
INSERT INTO `orders` VALUES (9, '20191003202444234855', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 903.00, '三方但是范德萨发生的', '2019-10-03 20:30:04', NULL, 'alipay', '2019100322001444151000063867', 'success', '182a5217fd244e2d872074ddd498df5c', 0, 1, 'received', '{\"express_company\":\"\\u97f5\\u8fbe\",\"express_no\":\"23013274343737363\"}', '{\"refund_reason\":\"23456789\"}', '2019-10-03 20:24:44', '2019-10-04 14:40:41');
INSERT INTO `orders` VALUES (10, '20191004010702621361', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 4586.00, 'jhfhjdsfhjdhjf', '2019-10-04 01:08:22', NULL, 'alipay', '2019100422001444151000062009', 'pending', NULL, 0, 1, 'received', '{\"express_company\":\"\\u97f5\\u8fbe\",\"express_no\":\"23013274343737364\"}', NULL, '2019-10-04 01:07:02', '2019-10-04 01:15:41');
INSERT INTO `orders` VALUES (11, '20191004155234197892', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 6457.00, 'regergreger', NULL, NULL, NULL, NULL, 'pending', NULL, 0, 0, 'pending', NULL, NULL, '2019-10-04 15:52:34', '2019-10-04 15:52:34');
INSERT INTO `orders` VALUES (12, '20191004161157778298', 1, '{\"address\":\"\\u6cb3\\u5317\\u7701\\u77f3\\u5bb6\\u5e84\\u5e02\\u957f\\u5b89\\u533a\\u7b2c70\\u8857\\u9053\\u7b2c788\\u53f7\",\"zip\":347800,\"contact_name\":\"\\u595a\\u6960\",\"contact_phone\":\"17615004944\"}', 3393.00, '213213123123', NULL, 11, NULL, NULL, 'pending', NULL, 0, 0, 'pending', NULL, NULL, '2019-10-04 16:11:57', '2019-10-04 16:11:57');
COMMIT;

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for product_skus
-- ----------------------------
DROP TABLE IF EXISTS `product_skus`;
CREATE TABLE `product_skus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '描述',
  `price` decimal(10,2) NOT NULL COMMENT '价格',
  `stock` int(10) unsigned NOT NULL COMMENT '评分',
  `product_id` bigint(20) unsigned NOT NULL COMMENT '关联的产品id',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_skus_product_id_foreign` (`product_id`),
  CONSTRAINT `product_skus_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of product_skus
-- ----------------------------
BEGIN;
INSERT INTO `product_skus` VALUES (1, '灰色 256g', 'iphone X 灰色 256g', 8888.00, 100, 1, '2019-09-30 09:57:39', '2019-09-30 09:57:39');
INSERT INTO `product_skus` VALUES (2, '灰色 521g', 'iphone X 白色64g', 11000.00, 100, 1, '2019-09-30 09:57:39', '2019-09-30 09:57:39');
INSERT INTO `product_skus` VALUES (3, 'et', 'Quod dicta ipsa debitis quas eos non eaque veniam.', 8818.00, 87559, 2, '2019-09-30 10:22:36', '2019-10-03 12:26:03');
INSERT INTO `product_skus` VALUES (4, 'et', 'Omnis placeat voluptatum consequatur velit.', 4586.00, 79360, 2, '2019-09-30 10:22:36', '2019-10-04 01:07:02');
INSERT INTO `product_skus` VALUES (5, 'aut', 'Et qui officiis quo adipisci ut maiores natus.', 5176.00, 64032, 2, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (6, 'dolorem', 'Occaecati odio optio accusamus fugiat quibusdam officia ut excepturi.', 7550.00, 91322, 3, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (7, 'voluptatibus', 'Rerum exercitationem ut repudiandae nesciunt qui.', 6457.00, 39737, 3, '2019-09-30 10:22:36', '2019-10-04 15:52:34');
INSERT INTO `product_skus` VALUES (8, 'dicta', 'Ut officiis consequuntur porro et.', 1428.00, 83523, 3, '2019-09-30 10:22:36', '2019-10-03 18:30:26');
INSERT INTO `product_skus` VALUES (9, 'optio', 'Deleniti voluptatum sequi harum qui ipsam.', 8231.00, 50170, 4, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (10, 'dicta', 'Sit quia incidunt eum enim ullam voluptate eum vero.', 9119.00, 76875, 4, '2019-09-30 10:22:36', '2019-10-03 18:03:53');
INSERT INTO `product_skus` VALUES (11, 'quam', 'Qui minus eligendi nihil repudiandae.', 7400.00, 12084, 4, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (12, 'consectetur', 'Accusantium esse officiis accusamus eos maxime.', 9106.00, 48982, 5, '2019-09-30 10:22:36', '2019-10-03 18:39:09');
INSERT INTO `product_skus` VALUES (13, 'iste', 'Doloremque non sed excepturi molestiae voluptate enim quaerat voluptas.', 3403.00, 33935, 5, '2019-09-30 10:22:36', '2019-10-04 16:11:57');
INSERT INTO `product_skus` VALUES (14, 'ducimus', 'Necessitatibus consequatur id iure unde earum.', 8863.00, 15202, 5, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (15, 'consectetur', 'Consequatur enim et nisi illo voluptates id.', 9112.00, 67716, 6, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (16, 'dolorem', 'Qui non sunt pariatur ut aperiam cumque aut.', 8970.00, 83089, 6, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (17, 'rerum', 'Temporibus sit dolor aut nihil tempora eos in.', 4565.00, 50883, 6, '2019-09-30 10:22:36', '2019-10-03 18:42:16');
INSERT INTO `product_skus` VALUES (18, 'nesciunt', 'Delectus autem perspiciatis ea omnis quisquam dolorum rerum.', 537.00, 42945, 7, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (19, 'cumque', 'Totam quis alias in ipsam dicta dolore.', 8985.00, 36276, 7, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (20, 'et', 'Est est iste laborum impedit numquam quae.', 9640.00, 11965, 7, '2019-09-30 10:22:36', '2019-10-03 20:51:47');
INSERT INTO `product_skus` VALUES (21, 'fuga', 'Corrupti labore ut et sed assumenda.', 2984.00, 83137, 8, '2019-09-30 10:22:36', '2019-10-03 19:34:43');
INSERT INTO `product_skus` VALUES (22, 'eaque', 'Facilis natus est totam ut odio excepturi.', 3316.00, 37110, 8, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (23, 'nihil', 'Unde quas ad incidunt expedita.', 395.00, 54750, 8, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (24, 'expedita', 'Facere deserunt quod a aperiam blanditiis dolorum eius dolorem.', 3445.00, 63701, 9, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (25, 'velit', 'Laboriosam recusandae rerum hic rem voluptatem mollitia.', 903.00, 27764, 9, '2019-09-30 10:22:36', '2019-10-03 20:24:44');
INSERT INTO `product_skus` VALUES (26, 'ullam', 'Quas consequatur accusantium nesciunt magni aperiam omnis possimus cum.', 2397.00, 69449, 9, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (27, 'saepe', 'Et dignissimos maxime earum distinctio et.', 2541.00, 94613, 10, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (28, 'omnis', 'Voluptatem ducimus qui laborum ducimus non voluptatum deserunt distinctio.', 7471.00, 49746, 10, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (29, 'quia', 'Et libero molestiae tenetur enim dignissimos nostrum.', 7664.00, 78360, 10, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (30, 'sunt', 'Magnam libero eum quas eligendi maxime asperiores molestiae magni.', 1283.00, 60333, 11, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (31, 'neque', 'Veritatis et et natus excepturi temporibus impedit.', 8607.00, 55227, 11, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (32, 'qui', 'Voluptatum dignissimos possimus voluptatum assumenda iure.', 7770.00, 2386, 11, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (33, 'illo', 'Autem hic unde quo molestias.', 5379.00, 31121, 12, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (34, 'facilis', 'Iure unde quia maxime aut et in odio.', 5974.00, 98801, 12, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (35, 'atque', 'Rerum enim nihil reiciendis doloribus consectetur laudantium atque.', 7922.00, 46866, 12, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (36, 'libero', 'Eligendi quam et reiciendis id nobis quis.', 7976.00, 42710, 13, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (37, 'quo', 'Veritatis suscipit sunt eius qui eos.', 117.00, 19853, 13, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (38, 'porro', 'Provident debitis fugit consequatur velit earum dignissimos est quam.', 828.00, 37981, 13, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (39, 'incidunt', 'Qui nisi voluptatem ut nihil ea veritatis.', 5823.00, 32925, 14, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (40, 'consequuntur', 'Ut non qui harum dolore et velit.', 5845.00, 75647, 14, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (41, 'sit', 'Accusantium nesciunt excepturi accusantium et.', 1789.00, 20413, 14, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (42, 'et', 'Illum laboriosam tenetur non laboriosam tenetur accusantium.', 1106.00, 16946, 15, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (43, 'totam', 'Provident ad voluptatem dolore repellendus ut.', 473.00, 94971, 15, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (44, 'dicta', 'Nesciunt in aliquam quod.', 3207.00, 57276, 15, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (45, 'dolorem', 'Architecto recusandae repellendus maxime nam vero quia eos.', 38.00, 21853, 16, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (46, 'tenetur', 'Nulla quis consequatur id eveniet.', 1098.00, 54716, 16, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (47, 'sint', 'Commodi ut corporis consequatur id non cupiditate ex.', 3458.00, 94677, 16, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (48, 'in', 'Recusandae quo sint maxime sequi praesentium quam.', 1570.00, 21676, 17, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (49, 'inventore', 'Qui consequatur accusamus autem reiciendis at perspiciatis odio.', 6979.00, 82292, 17, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (50, 'rem', 'Ducimus inventore possimus dolorum maxime.', 7662.00, 12717, 17, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (51, 'fuga', 'Fugiat vero rerum aut quis fugit odit reiciendis.', 3145.00, 89735, 18, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (52, 'sed', 'Beatae et eum ut fugit.', 8334.00, 20415, 18, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (53, 'repudiandae', 'Nihil nisi et similique debitis.', 1088.00, 57465, 18, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (54, 'adipisci', 'Quis voluptatem eligendi qui et.', 4642.00, 74345, 19, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (55, 'explicabo', 'Doloremque ab perferendis dolore tempora consequatur non dolor aliquam.', 3232.00, 85740, 19, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (56, 'quis', 'Dolorem excepturi voluptate repellendus iste maxime.', 8880.00, 90795, 19, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (57, 'ut', 'Vel quibusdam cum quam voluptatum ut ullam.', 2959.00, 53469, 20, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (58, 'numquam', 'Omnis et quasi harum consectetur ut aut.', 9363.00, 57154, 20, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (59, 'voluptates', 'Rerum perferendis magni sint perferendis.', 5857.00, 25360, 20, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (60, 'minima', 'Fugit dicta sequi fugiat sed non aut voluptatum.', 5415.00, 98878, 21, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (61, 'consectetur', 'Quas quibusdam accusantium occaecati autem mollitia aliquid atque.', 5335.00, 3964, 21, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (62, 'accusantium', 'Aut ducimus quam saepe.', 9907.00, 60027, 21, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (63, 'veritatis', 'Laboriosam quisquam est alias doloremque qui sapiente nam ut.', 417.00, 15675, 22, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (64, 'exercitationem', 'Aut provident est neque perferendis velit blanditiis.', 2149.00, 41077, 22, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (65, 'rerum', 'Aut sed repellat laudantium laboriosam ad facere et.', 5023.00, 20592, 22, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (66, 'reiciendis', 'Voluptatem adipisci vero voluptates a eius.', 2406.00, 2220, 23, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (67, 'aut', 'Quaerat id facere totam nobis.', 9575.00, 10304, 23, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (68, 'maiores', 'Veniam voluptatem doloribus eveniet et veniam.', 9586.00, 90591, 23, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (69, 'voluptatem', 'Doloremque placeat suscipit voluptatibus omnis.', 2904.00, 33705, 24, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (70, 'qui', 'Voluptas et et voluptatem provident suscipit.', 3396.00, 26641, 24, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (71, 'omnis', 'Velit omnis consequatur adipisci nihil in deserunt.', 267.00, 57221, 24, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (72, 'voluptatum', 'Quidem iusto eos culpa unde.', 2348.00, 96178, 25, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (73, 'veniam', 'Qui et rerum id et libero vero omnis.', 3470.00, 19451, 25, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (74, 'sed', 'Fuga minus numquam veritatis qui.', 4640.00, 83639, 25, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (75, 'nihil', 'Perspiciatis reiciendis rerum illum id voluptatem distinctio minus.', 4918.00, 53525, 26, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (76, 'vel', 'Rerum eaque eum maxime dignissimos et ipsum sit.', 6225.00, 13519, 26, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (77, 'distinctio', 'Iure quaerat ut perspiciatis.', 5286.00, 87980, 26, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (78, 'possimus', 'Qui id excepturi eum ducimus qui sint assumenda.', 4005.00, 55349, 27, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (79, 'aut', 'Ut cumque ducimus itaque magnam consequatur qui.', 514.00, 84565, 27, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (80, 'sunt', 'Possimus sequi eum soluta sed quo nulla voluptas.', 196.00, 73116, 27, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (81, 'sed', 'Quia qui voluptas non quod est.', 2441.00, 43390, 28, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (82, 'quia', 'Ut excepturi non dolore animi aliquid molestias ut.', 3915.00, 1651, 28, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (83, 'facere', 'Occaecati sed atque consequatur pariatur eius eaque.', 8258.00, 80665, 28, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (84, 'sit', 'Impedit sunt quia beatae tenetur voluptatem laboriosam voluptas amet.', 318.00, 84983, 29, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (85, 'enim', 'Esse aspernatur laudantium accusantium provident ipsam.', 2743.00, 70569, 29, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (86, 'necessitatibus', 'Voluptate sint in voluptatem et.', 2374.00, 85149, 29, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (87, 'eos', 'Dolor officiis sit perspiciatis inventore quis ut.', 3627.00, 76258, 30, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (88, 'rem', 'Rerum error maiores et occaecati quasi et.', 199.00, 96243, 30, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (89, 'sunt', 'Iusto aliquid at odit.', 3653.00, 25030, 30, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (90, 'consequatur', 'Ut omnis id temporibus quia et.', 4106.00, 46171, 31, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (91, 'rerum', 'Dolor fugit cumque quia quia.', 8932.00, 83925, 31, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `product_skus` VALUES (92, 'temporibus', 'Aut illo facilis qui vel aut non.', 1008.00, 73484, 31, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
COMMIT;

-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品名称',
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品详情',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品路径',
  `on_sale` tinyint(1) NOT NULL DEFAULT '1' COMMENT '商品是否售卖',
  `rating` double(8,2) NOT NULL DEFAULT '5.00' COMMENT '评分',
  `sold_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '销量',
  `review_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '评价数量',
  `price` decimal(10,2) NOT NULL COMMENT '最低价格',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of products
-- ----------------------------
BEGIN;
INSERT INTO `products` VALUES (1, 'Apple/苹果 Iphone X', '<p>Iphone X 概念版</p>', 'images/1.jpeg', 0, 5.00, 0, 0, 8888.00, '2019-09-30 09:57:39', '2019-10-03 12:23:03');
INSERT INTO `products` VALUES (2, 'qui', 'Totam aperiam voluptatum porro nesciunt animi ad est.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/82Wf2sg8gM.jpg', 1, 5.00, 1, 1, 4586.00, '2019-09-30 10:22:36', '2019-10-04 01:12:27');
INSERT INTO `products` VALUES (3, 'consectetur', 'Natus nostrum sit enim impedit.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 0.00, 0, 0, 1428.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (4, 'fugit', 'Omnis facere repellat et porro.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 0.00, 0, 0, 7400.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (5, 'laborum', 'Sed hic magnam reprehenderit mollitia voluptate.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/uYEHCJ1oRp.jpg', 1, 4.00, 0, 0, 3403.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (6, 'aut', 'Nobis quo doloremque porro similique possimus soluta a incidunt.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/nIvBAQO5Pj.jpg', 1, 5.00, 0, 0, 4565.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (7, 'rerum', 'Amet dicta sed suscipit aut velit.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/1B3n0ATKrn.jpg', 1, 0.00, 0, 0, 537.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (8, 'perspiciatis', 'Et illo blanditiis aliquam eum.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/XrtIwzrxj7.jpg', 1, 2.00, 0, 0, 395.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (9, 'modi', 'Eos cupiditate iste illum quis neque consequatur et.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 2.00, 1, 0, 903.00, '2019-09-30 10:22:36', '2019-10-03 21:18:55');
INSERT INTO `products` VALUES (10, 'ab', 'Explicabo facere facilis aliquam quibusdam et reiciendis.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/uYEHCJ1oRp.jpg', 1, 0.00, 0, 0, 2541.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (11, 'vero', 'Quidem hic voluptates repellendus praesentium accusantium tenetur et.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/XrtIwzrxj7.jpg', 1, 0.00, 0, 0, 1283.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (12, 'dolore', 'Est repellat necessitatibus qui nihil autem.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/XrtIwzrxj7.jpg', 1, 0.00, 0, 0, 5379.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (13, 'tenetur', 'Maxime sed enim dolorum cumque.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/pa7DrV43Mw.jpg', 1, 4.00, 0, 0, 117.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (14, 'possimus', 'Et molestiae aut nemo quis.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/r3BNRe4zXG.jpg', 1, 0.00, 0, 0, 1789.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (15, 'laudantium', 'Et necessitatibus perferendis eos iure.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/pa7DrV43Mw.jpg', 1, 2.00, 0, 0, 473.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (16, 'suscipit', 'Quia laudantium modi distinctio repudiandae dolore aut asperiores.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/C0bVuKB2nt.jpg', 1, 1.00, 0, 0, 38.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (17, 'vero', 'Atque doloribus eveniet labore voluptatum sint quas.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/nIvBAQO5Pj.jpg', 1, 4.00, 0, 0, 1570.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (18, 'exercitationem', 'Ipsam et qui aut autem ullam et sit.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/uYEHCJ1oRp.jpg', 1, 5.00, 0, 0, 1088.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (19, 'eius', 'Adipisci voluptatem animi omnis placeat provident vero ipsum.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/uYEHCJ1oRp.jpg', 1, 2.00, 0, 0, 3232.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (20, 'pariatur', 'Eos minima sunt quis quo officia explicabo qui distinctio.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 5.00, 0, 0, 2959.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (21, 'deserunt', 'Voluptatem molestiae velit error et ipsam.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/82Wf2sg8gM.jpg', 1, 4.00, 0, 0, 5335.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (22, 'fugit', 'Dicta quis soluta amet dolores.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 0.00, 0, 0, 417.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (23, 'quos', 'Veniam deserunt nam id eveniet asperiores.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/1B3n0ATKrn.jpg', 1, 1.00, 0, 0, 2406.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (24, 'temporibus', 'Officiis voluptatum dolorum eligendi et provident.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/C0bVuKB2nt.jpg', 1, 2.00, 0, 0, 267.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (25, 'dicta', 'Cum deserunt unde sed sed.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 0.00, 0, 0, 2348.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (26, 'saepe', 'Quia quis quidem qui quis.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 1.00, 0, 0, 4918.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (27, 'tenetur', 'Incidunt enim aliquam vel enim explicabo sunt.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/1B3n0ATKrn.jpg', 1, 1.00, 0, 0, 196.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (28, 'voluptatibus', 'Unde sint similique rem illo.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 1.00, 0, 0, 2441.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (29, 'minus', 'Tempore omnis voluptas quia et veniam.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/nIvBAQO5Pj.jpg', 1, 1.00, 0, 0, 318.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (30, 'asperiores', 'Inventore minus doloremque modi odit blanditiis vero alias at.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/2JMRaFwRpo.jpg', 1, 1.00, 0, 0, 199.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
INSERT INTO `products` VALUES (31, 'ipsum', 'Quia eligendi assumenda non qui esse placeat.', 'https://cdn.learnku.com/uploads/images/201806/01/5320/r3BNRe4zXG.jpg', 1, 3.00, 0, 0, 1008.00, '2019-09-30 10:22:36', '2019-09-30 10:22:36');
COMMIT;

-- ----------------------------
-- Table structure for user_addresses
-- ----------------------------
DROP TABLE IF EXISTS `user_addresses`;
CREATE TABLE `user_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL COMMENT '关联用户id',
  `province` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '省',
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '市',
  `district` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '区',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '地址',
  `zip` int(10) unsigned NOT NULL COMMENT '邮编',
  `contact_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '联系人',
  `contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '联系电话',
  `last_used_at` datetime DEFAULT NULL COMMENT '最后使用时间',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_addresses_user_id_foreign` (`user_id`),
  CONSTRAINT `user_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user_addresses
-- ----------------------------
BEGIN;
INSERT INTO `user_addresses` VALUES (3, 1, '河北省', '石家庄市', '长安区', '第70街道第788号', 347800, '奚楠', '17615004944', '2019-10-04 16:11:57', '2019-09-29 17:26:09', '2019-10-04 16:11:57');
INSERT INTO `user_addresses` VALUES (4, 1, '辽宁省', '锦州市', '黑山县', '第72街道第195号2栋', 118550, '磊磊7', '18061872309', NULL, '2019-09-29 23:26:30', '2019-09-29 23:39:42');
INSERT INTO `user_addresses` VALUES (5, 1, '山西省', '长治市', '襄垣县', '第72街道第195号', 213213, '磊磊2', '18061872344', NULL, '2019-09-29 23:47:55', '2019-09-29 23:48:05');
COMMIT;

-- ----------------------------
-- Table structure for user_favorite_products
-- ----------------------------
DROP TABLE IF EXISTS `user_favorite_products`;
CREATE TABLE `user_favorite_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL COMMENT '关联用户id',
  `product_id` bigint(20) unsigned NOT NULL COMMENT '关联商品id',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_favorite_products_user_id_foreign` (`user_id`),
  KEY `user_favorite_products_product_id_foreign` (`product_id`),
  CONSTRAINT `user_favorite_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_favorite_products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user_favorite_products
-- ----------------------------
BEGIN;
INSERT INTO `user_favorite_products` VALUES (2, 1, 1, '2019-09-30 11:41:13', '2019-09-30 11:41:13');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (1, '磊磊', 'zhu8702692@163.com', '2019-09-29 17:01:26', '$2y$10$sl84HzKiwwgyygYKQaMiVOi1OOvSMEo5o.l/S70LqJsgaH.twhIMy', 'UohsOiwgjWV1grYVd2aB6faHMeEQ8yUdfapwXrYcwnqrD57aA0CIjypBtW3e', '2019-09-29 08:52:03', '2019-09-29 08:52:03');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
